Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_JOBS

`ALL_JOBS` describes all jobs in the database that are accessible to the current user.

See Also: Oracle Database Administrator's Guide

Related Views

- `DBA_JOBS` describes all jobs in the database.

- `USER_JOBS` describes all jobs owned by the current user.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`JOB` | `NUMBER` | `NOT NULL` | Identifier of job. Neither import/export nor repeated executions change this value.
`LOG_USER` | `VARCHAR2(30)` | `NOT NULL` | Login user when the job was submitted
`PRIV_USER` | `VARCHAR2(30)` | `NOT NULL` | User whose default privileges apply to this job
`SCHEMA_USER` | `VARCHAR2(30)` | `NOT NULL` | Default schema used to parse the job For example, if the `SCHEMA_USER` is `SCOTT` and you submit the procedure `HIRE_EMP` as a job, the Oracle Database looks for `SCOTT`.`HIRE_EMP`
`LAST_DATE` | `DATE` |  | Date on which this job last successfully executed
`LAST_SEC` | `VARCHAR2(8)` |  | Same as `LAST_DATE`. This is when the last successful execution started.
`THIS_DATE` | `DATE` |  | Date that this job started executing (usually null if not executing)
`THIS_SEC` | `VARCHAR2(8)` |  | Same as `THIS_DATE`. This is when the last successful execution started.
`NEXT_DATE` | `DATE` | `NOT NULL` | Date that this job will next be executed
`NEXT_SEC` | `VARCHAR2(8)` |  | Same as `NEXT_DATE`. This is when the last successful execution started.
`TOTAL_TIME` | `NUMBER` |  | Total wall clock time spent by the system on this job, in seconds
`BROKEN` | `VARCHAR2(1)` |  | `Y`: no attempt is made to run this job `N`: an attempt is made to run this job
`INTERVAL` | `VARCHAR2(200)` | `NOT NULL` | A date function, evaluated at the start of execution, becomes next `NEXT_DATE`
`FAILURES` | `NUMBER` |  | Number of times the job has started and failed since its last success
`WHAT` | `VARCHAR2(4000)` |  | Body of the anonymous PL/SQL block that the job executes
`NLS_ENV` | `VARCHAR2(4000)` |  | Session parameters describing the NLS environment of the job
`MISC_ENV` | `RAW(32)` |  | Other session parameters that apply to this job
`INSTANCE` | `NUMBER` |  | ID of the instance that can execute or is executing the job. The default is 0.